package nus.edu.sg.main;

import java.math.BigDecimal;
import java.sql.Timestamp;
import java.util.*;

public interface IDBDashboard {

	public BigDecimal getOverallPerformance(String parameterId,
			Timestamp starTime, Timestamp endTime) throws Exception;

	public ArrayList<String> getAdvices(String parameterId, Timestamp time)
			throws Exception;
	
	public String getAwrReport(Timestamp startTime, Timestamp endTime)
			throws Exception;

	public HashMap<Long, String> getPerformanceBreakdown(String parameterId,
			String level, Timestamp starTime, Timestamp endTime)
			throws Exception;

	public void configureSampleTimes(int x, int y, int z) throws Exception;

	public ArrayList <String[]> getSqlResult(String sqlQuery) throws Exception;
}
